CREATE VIEW [dbo].[vw_EShopGoods]
AS
SELECT good.Id,
       good.K_Code AS Code,
       good.Barcode,
       good.Name1 AS Name,
       good.Name2 AS Alias,
       g.Id AS GroupId,
       good.Eshop_Flag AS isActive,
       u1.Id AS UnitId,
       good.SalesCeiling,
       good.MinQtyTelegram,
       u2.Id AS unit2Id,
       good.R_Unit1_2,
       good.Duty_Flag,
       CASE
           WHEN ISNULL(good.Duty_Flag, 0) = 1
                AND good.TaxPercent > 0 THEN
               CAST(good.TaxPercent AS INT)
           WHEN ISNULL(good.Duty_Flag, 0) = 1
                AND good.TaxPercent = 0 THEN
           (
               SELECT TOP 1
                      CAST(Max_Percent AS INT)
               FROM dbo.Over_Under
               WHERE Action_Code = 7
                     AND TaxTransactionType = 3
                     AND Active = 1
                     AND CAST(GETDATE() AS DATE)
                     BETWEEN AzTarikh AND TaTarikh
           )
           WHEN ISNULL(good.Duty_Flag, 0) = 0 THEN
               0

       END AS TaxationPercent
FROM dbo.KalaId AS good
    INNER JOIN dbo.Unit1 AS u1
        ON good.U_Code1 = u1.U_Code1
    LEFT OUTER JOIN dbo.Unit2 AS u2
        ON good.U_Code2 = u2.U_Code2
    LEFT OUTER JOIN dbo.Group1 AS g
        ON g.Gid = good.Gid_Fk


	



